/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : localhost:3306
 Source Schema         : db_warehouse

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 07/02/2025 18:00:15
*/

drop database if exists db_warehouse;
create database db_warehouse charset utf8;
use db_warehouse;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_info
-- ----------------------------
DROP TABLE IF EXISTS `auth_info`;
CREATE TABLE `auth_info` (
  `auth_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限id',
  `parent_id` int(11) DEFAULT NULL COMMENT '权限父id，当父id为0，表示一级权限',
  `auth_name` varchar(100) DEFAULT NULL COMMENT '权限名',
  `auth_desc` varchar(300) DEFAULT NULL COMMENT '权限内容描述',
  `auth_grade` int(11) DEFAULT NULL COMMENT '权限等级，共3级',
  `auth_type` char(1) DEFAULT NULL COMMENT '权限类型：1 模块 、2  列表、 3  按钮',
  `auth_url` varchar(100) DEFAULT NULL COMMENT '权限url',
  `auth_code` varchar(100) DEFAULT NULL COMMENT '权限代码',
  `auth_order` int(11) DEFAULT NULL COMMENT '权限顺序',
  `auth_state` char(1) DEFAULT '1' COMMENT '权限状态：1 启用 、0 禁用',
  `create_by` int(11) DEFAULT NULL COMMENT '创建权限的用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` int(11) DEFAULT NULL COMMENT '更新权限的用户id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`auth_id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Records of auth_info
-- ----------------------------
BEGIN;
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, 0, '用户管理', '用户管理', 1, '1', NULL, NULL, 1, '1', 1, '2023-11-14 16:54:13', 1, '2023-11-14 16:54:17');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2, 1, '用户列表', '用户列表', 2, '2', '/user/index', NULL, 99, '1', 1, '2023-11-14 16:56:11', 1, '2023-11-14 16:56:15');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (3, 2, '添加用户', '添加用户', 3, '3', NULL, 'user-addUser', 99, '1', 1, '2023-11-14 16:56:59', 1, '2023-11-14 16:57:02');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (4, 0, '角色管理', '角色管理', 1, '1', NULL, NULL, 2, '1', 1, '2023-11-14 16:57:48', 1, '2023-11-14 16:57:52');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (5, 4, '角色列表', '角色列表', 2, '2', '/role/index', NULL, 99, '1', 1, '2023-11-14 16:58:47', 1, '2023-11-14 16:58:50');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (6, 5, '添加角色', '添加角色', 3, '3', NULL, 'role-addRole', 99, '1', 1, '2023-11-14 16:59:25', 1, '2023-11-14 16:59:29');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (7, 0, '权限管理', '权限管理', 1, '1', NULL, NULL, 3, '1', 1, '2023-11-14 17:00:13', 1, '2023-11-14 17:00:18');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (8, 7, '权限树', '权限树', 2, '2', '/auth/index', NULL, 99, '1', 1, '2023-11-14 17:02:11', 1, '2023-11-14 17:02:14');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (9, 8, '添加权限', '添加权限', 3, '3', NULL, 'auth-addAuth', 99, '1', 1, '2023-11-14 17:03:48', 1, '2023-11-14 17:03:52');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (10, 2, '删除用户', '删除用户', 3, '3', '', 'user-deleteUser', 99, '1', 1, '2023-11-23 11:56:17', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (19, 0, '订单管理', '订单管理', 1, '1', '', '', 10, '0', 1, '2023-11-23 17:31:08', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (20, 19, '订单列表', '订单列表', 2, '2', '', '', 99, '1', 1, '2023-11-23 17:31:42', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (21, 20, '修改订单', '修改订单', 3, '3', '', 'updateOrder', 99, '1', 1, '2023-11-24 14:33:23', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (22, 20, '删除订单', '删除订单', 3, '3', '', 'auth-delete', 99, '1', 1, '2023-11-24 14:34:32', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (23, 2, '查询用户', '查询用户', 3, '3', '', 'user-findUser', 99, '1', 1, '2023-11-28 10:10:53', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (24, 2, '修改用户', '修改用户信息', 3, '3', '', 'user-updateUser', 99, '1', 1, '2023-11-28 10:12:51', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (25, 2, '分配角色', '分配角色', 3, '3', '', 'user-assignRole', 99, '1', 1, '2023-11-28 10:15:27', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (26, 2, '更改权限', '更改权限', 3, '3', '', 'user-updateAuth', 99, '1', 1, '2023-11-28 10:16:07', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (27, 5, '修改角色', '修改角色', 3, '3', '', 'role-updateRole', 99, '1', 1, '2023-11-28 10:16:40', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (28, 5, '查询角色', '查询角色', 3, '3', '', 'role-findRole', 99, '1', 1, '2023-11-28 10:17:12', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (30, 5, '删除角色', '删除角色', 3, '3', '', 'role-deleteRole', 99, '1', 1, '2023-11-28 10:23:14', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (31, 5, '更改权限', '更改权限', 3, '3', '', 'role-updateAuth', 99, '1', 1, '2023-11-28 10:24:35', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (32, 8, '修改权限', '修改权限', 3, '3', '', 'auth-updateAuth', 99, '1', 1, '2023-11-28 10:25:08', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (33, 8, '删除权限', '删除权限', 3, '3', NULL, 'auth-deleteAuth', 99, '1', 1, '2023-03-29 10:10:03', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (34, 8, '恢复权限', '恢复权限', 3, '3', NULL, 'auth-restartAuth', 99, '1', 1, '2023-03-29 10:10:50', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (35, 2, '修改状态', '修改状态', 3, '3', '', 'user-updateState', 99, '1', 1, '2023-11-28 10:49:40', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (36, 2, '重置密码', '重置密码', 3, '3', '', 'user-resetPwd', 99, '1', 1, '2023-11-28 10:53:27', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (37, 5, '修改角色状态', '修改角色状态', 3, '3', '', 'role-updateState', 99, '1', 1, '2023-11-28 11:12:23', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (38, 19, '订单详情', '订单详情', 2, '2', '', '', 99, '1', 1, '2023-11-29 11:35:57', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (41, 19, '订单分类', '订单分类', 2, '2', '', '', 99, '1', 1, '2023-11-29 11:56:04', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (42, 0, '商品管理', '商品管理', 1, '1', '', '', 4, '1', 1, '2023-11-29 11:56:44', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (43, 38, '查看详情', '查看详情', 3, '3', '', 'order-selectDetils', 99, '1', 1, '2023-11-29 11:57:29', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (44, 38, '修改详情', '修改详情', 3, '3', '', 'order-updateDetils', 99, '1', 1, '2023-11-29 11:58:36', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (46, 41, '分类', '分类', 3, '3', '', 'auth-flAuth', 99, '1', 1, '2023-11-30 15:16:02', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (50, 42, '商品列表', '商品列表', 2, '2', '/commodity/index', '', 99, '1', 1, '2023-12-07 08:47:50', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (53, 0, '采购管理', '采购管理', 1, '1', '', '', 5, '1', 1, '2023-12-11 14:53:02', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (54, 0, '入库管理', '入库管理', 1, '1', '', '', 6, '1', 1, '2023-12-11 14:53:20', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (55, 0, '出库管理', '出库管理', 1, '1', '', '', 7, '1', 1, '2023-12-11 14:53:31', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (56, 53, '采购列表', '采购列表', 2, '2', '/purchase/index', '', 99, '1', 1, '2023-12-11 14:59:11', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (57, 54, '入库列表', '入库列表', 2, '2', '/instore/index', '', 99, '1', 1, '2023-12-11 15:01:27', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (58, 55, '出库列表', '出库列表', 2, '2', '/outstore/index', '', 99, '1', 1, '2023-12-11 15:02:03', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (61, 0, '盘点管理', '盘点管理', 1, '1', '', '', 11, '1', 1, '2023-12-11 18:04:38', 1, '2024-10-25 11:44:30');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (62, 61, '盘点列表', '盘点列表', 2, '2', '', '', 99, '1', 1, '2023-12-11 18:05:05', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (63, 0, '统计查询', '统计查询', 1, '1', '', '', 12, '1', 1, '2023-12-12 14:17:13', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (64, 63, '统计报表', '统计报表', 2, '2', '/statistics/index', '', 99, '1', 1, '2023-12-12 14:17:43', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (65, 0, '站内通知', '', 1, '1', '', '', 13, '1', 1, '2023-12-12 17:47:22', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (66, 65, '站内信', '', 2, '2', '', '', 99, '1', 1, '2023-12-12 17:49:10', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (67, 65, '我的站内信', '', 2, '2', '', '', 99, '1', 1, '2023-12-12 17:49:46', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (68, 0, '调货管理', '调货管理', 1, '1', '', '', 8, '1', 1, '2023-12-13 14:34:21', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (69, 0, '基础数据', '基础数据', 1, '1', '', '', 9, '1', 1, '2023-12-13 14:34:48', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (70, 69, '仓库管理', '仓库管理', 2, '2', '/store/index', '', 99, '1', 1, '2023-12-13 14:36:32', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (71, 68, '调货单列表', '调货单列表', 2, '2', '/transshipment/index', NULL, 99, '1', 1, NULL, NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (74, 69, '供货商管理', '供货商管理', 2, '2', '/supply/index', '', 99, '1', 1, '2023-12-13 17:10:14', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (75, 69, '产地管理', '产地管理', 2, '2', '/place/index', '', 99, '1', 1, '2023-12-13 17:10:36', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (76, 42, '商品分类', '商品分类', 2, '2', '/commodity/category', '', 99, '1', 1, '2023-12-14 11:16:38', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (92, 50, '调货', '调货', 3, '3', '/transshipment/transfer', 'transfer_commodity', 99, '1', 1, '2023-04-22 12:17:19', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (93, 50, '商品查询', '商品查询', 3, '3', '/product/product-page-list', 'select_product', 99, '1', 1, '2023-04-22 12:21:37', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (94, 50, '添加商品', '添加商品', 3, '3', '/product/product-add', 'product-add', 99, '1', 1, '2023-04-22 12:23:17', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (95, 57, '确定入库', '确定入库', 3, '3', '/instore/instore-confirm', 'instore-confirm', 99, '1', 1, '2023-04-22 12:25:36', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (96, 71, '确认调货', '确认调货', 3, '3', '/transshipment/transshipment-confirm', 'transshipment-confirm', 99, '1', 1, '2023-04-22 12:26:59', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (97, 50, '采购', '采购', 3, '3', '/purchase/purchase-add', 'purchase-add', 99, '1', 1, '2023-04-22 12:30:42', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (98, 63, '大屏看板', '大屏看板', 2, '2', '/statistics/board', NULL, 100, '1', 1, '2024-09-18 15:55:20', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (99, 68, '调货列表', '调货列表', 2, '2', '/transshipment/transfer', NULL, 98, '1', 1, '2024-09-18 17:25:47', NULL, NULL);
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (100, 0, '首页', '首页', 1, '1', '', '', 0, '1', 1, '2024-10-25 11:27:39', 1, '2024-10-25 11:27:39');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (101, 100, '待办事项', '待办事项', 2, '2', '/index/index', '', NULL, '1', 1, '2024-10-25 11:34:14', 1, '2024-10-25 11:34:14');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (102, 0, '系统日志', '系统日志', 1, '1', '', '', 14, '1', 1, '2024-10-29 08:34:30', 1, '2024-10-29 08:34:30');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (103, 102, '操作日志', '操作日志', 2, '2', '/log/operlog', '', 101, '1', 1, '2024-10-29 08:35:36', 1, '2024-10-29 08:35:36');
INSERT INTO `auth_info` (`auth_id`, `parent_id`, `auth_name`, `auth_desc`, `auth_grade`, `auth_type`, `auth_url`, `auth_code`, `auth_order`, `auth_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (104, 102, '登录日志', '登录日志', 2, '2', '/log/loginlog', '', 102, '1', 1, '2024-10-29 08:36:01', 1, '2024-10-29 08:36:01');
COMMIT;

-- ----------------------------
-- Table structure for brand
-- ----------------------------
DROP TABLE IF EXISTS `brand`;
CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '品牌id',
  `brand_name` varchar(100) DEFAULT NULL COMMENT '品牌名',
  `brand_leter` char(1) DEFAULT NULL COMMENT '品牌首字母',
  `brand_desc` varchar(1000) DEFAULT NULL COMMENT '品牌描述',
  PRIMARY KEY (`brand_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='品牌表';

-- ----------------------------
-- Records of brand
-- ----------------------------
BEGIN;
INSERT INTO `brand` (`brand_id`, `brand_name`, `brand_leter`, `brand_desc`) VALUES (1, '东东果蔬', 'D', '别买了，不能吃...');
INSERT INTO `brand` (`brand_id`, `brand_name`, `brand_leter`, `brand_desc`) VALUES (2, '美的', 'M', '还可以');
INSERT INTO `brand` (`brand_id`, `brand_name`, `brand_leter`, `brand_desc`) VALUES (3, '海尔', 'H', '我家洗衣机就是海尔啊');
INSERT INTO `brand` (`brand_id`, `brand_name`, `brand_leter`, `brand_desc`) VALUES (4, '华为', 'H', '中华有为');
COMMIT;

-- ----------------------------
-- Table structure for buy_list
-- ----------------------------
DROP TABLE IF EXISTS `buy_list`;
CREATE TABLE `buy_list` (
  `buy_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '采购单id',
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `buy_num` int(11) DEFAULT NULL COMMENT '预计采购数量',
  `fact_buy_num` int(11) DEFAULT NULL COMMENT '实际采购数量',
  `buy_time` datetime DEFAULT NULL COMMENT '采购时间',
  `supply_id` int(11) DEFAULT NULL COMMENT '供应商id',
  `place_id` int(11) DEFAULT NULL COMMENT '产地id',
  `buy_user` varchar(20) DEFAULT NULL COMMENT '采购人名',
  `phone` varchar(20) DEFAULT NULL COMMENT '采购人电话',
  `is_in` char(1) DEFAULT NULL COMMENT '入库状态：0 否 1 是',
  PRIMARY KEY (`buy_id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8 COMMENT='采购单表';

-- ----------------------------
-- Records of buy_list
-- ----------------------------
BEGIN;
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (1, 1, 1, 200, 198, '2023-12-19 09:45:49', 1, 2, 'rose', '13474421775', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (2, 5, 2, 366, 299, '2023-12-11 09:47:55', 2, 3, 'Jack', '13425431443', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (3, 6, 3, 499, 0, '2023-12-26 08:14:54', 3, 5, 'json', '12435642334', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (4, 7, 2, 899, 400, '2023-12-18 08:21:12', 3, 4, 'Abby', '13657867789', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (5, 11, 1, 299, 123, '2023-12-07 21:27:53', 1, 1, '杨洋', '13567589887', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (6, 12, 1, 299, 200, '2023-02-07 21:28:43', 1, 1, '杨洋', '13567589887', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (7, 13, 1, 3666, 399, '2023-12-07 21:29:24', 1, 1, '赵丽颖', '15757483376', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (8, 14, 1, 8, 0, '2023-12-07 21:54:16', 1, 1, '张三', '12455546785', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (9, 1, 1, 234, 33, '2023-12-07 22:10:22', 1, 1, '李四', '15647864467', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (10, 1, 1, 235, 0, '2023-12-07 22:14:02', 1, 1, '王麻子', '18349274483', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (11, 5, 1, 600, 600, '2023-04-11 15:37:10', 2, 2, 'zhang', '14647386684', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (12, 5, 1, 555, 550, '2023-12-11 15:39:51', 2, 3, 'liu', '46462275758', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (13, 5, 1, 666, 600, '2023-12-11 15:40:43', 2, 3, 'james', '35436375757', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (14, 5, 1, 666, 0, '2023-12-11 17:27:13', 2, 3, 'kobe', '35436375757', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (15, 6, 2, 33, 33, '2023-12-12 10:19:32', 2, 2, 'tom', NULL, '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (16, 6, 3, 44, 44, '2023-12-12 10:19:44', 2, 2, 'frank', NULL, '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (17, 6, 2, 55, 53, '2023-12-12 10:20:09', 1, 3, 'hello', NULL, '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (18, 7, 1, 66, 1, '2023-04-12 10:20:26', 1, 2, 'mary', NULL, '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (19, 14, 1, 22, 10, '2023-04-13 10:20:38', 2, 1, 'alise', NULL, '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (20, 19, 1, 499, 0, '2023-04-13 10:28:39', 2, 2, 'mark', '46462275758', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (21, 22, 1, 700, 666, '2023-04-14 10:29:49', 2, 2, 'scott', '14647386684', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (22, 23, 1, 388, 300, '2023-03-12 10:31:06', 2, 3, 'jerry', '14647386684', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (23, 21, 1, 700, 400, '2023-04-12 10:32:17', 2, 2, 'john', '46462275758', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (25, 19, 1, 700, 700, '2023-04-12 10:43:45', 2, 2, 'zhang', '14647386684', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (26, 14, 1, 389, 300, '2023-01-14 11:10:47', 2, 2, 'messi', '12412412412', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (27, 21, NULL, NULL, NULL, '2023-04-19 11:42:19', NULL, NULL, NULL, NULL, '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (28, 22, 1, 100, 50, '2023-04-19 11:58:05', 5, 6, 'wk', '12345678987', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (29, 21, 1, 2, NULL, '2023-04-19 12:06:14', 2, 4, 'vick', '1234565432354', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (30, 21, 1, 3, NULL, '2023-04-19 12:09:29', 2, 4, 'mel', '33333333333', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (31, 22, 1, 5, NULL, '2023-04-19 12:13:23', 5, 6, 'vick', '44444444444', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (32, 21, 1, 8, 6, '2023-04-19 12:17:53', 2, 4, 'wr', '55555555555', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (35, 21, 1, 34, 20, '2023-04-19 18:00:09', 2, 4, 'href', '12345678234', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (36, 21, 1, 50, 10, '2023-04-19 18:01:15', 2, 4, 'alise', '12345678932', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (37, 22, 1, 500, 50, '2023-04-19 18:02:48', 5, 6, 'sam', '17654895432', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (38, 23, 2, 100, NULL, '2023-04-19 18:21:04', 5, 6, 'butt', '12345654327', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (39, 23, 2, 188, NULL, '2023-04-19 18:27:00', 5, 6, 'berne', '12345678742', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (40, 21, 1, 100, NULL, '2023-04-19 18:39:30', 2, 4, 'justin', '19875673733', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (41, 19, 2, 100, NULL, '2023-04-19 18:41:17', 2, 3, 'messi2', '16274987263', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (42, 6, 2, 40, NULL, '2023-04-19 18:43:17', 2, 4, 'kate', '12876543216', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (43, 6, 2, 20, NULL, '2023-04-19 18:45:54', 2, 4, 'zhang', '17654328765', '0');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (44, 7, 1, 20, 15, '2023-04-21 08:53:20', 4, 5, 'jerry', '12345678652', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (45, 22, 1, 23, 20, '2023-04-22 08:48:22', 5, 6, 'ww', '12345678921', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (46, 25, 1, 20, 15, '2023-04-22 11:53:08', 5, 6, 'lisi', '12345678954', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (47, 25, 1, 100, 80, '2023-04-24 15:50:33', 5, 6, 'h5', '19893748542', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (48, 6, 2, 20, 30, '2024-09-14 16:00:29', 2, 4, '张三', '13333333333', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (49, 6, 2, 10, 20, '2024-09-18 10:37:49', 2, 4, '张三', '13888888888', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (50, 6, 2, 100, 100, '2024-09-18 14:28:46', 2, 4, '李四', '13666666666', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (51, 6, 2, 100, 100, '2024-09-18 14:32:57', 2, 4, '张三', '13555555555', '1');
INSERT INTO `buy_list` (`buy_id`, `product_id`, `store_id`, `buy_num`, `fact_buy_num`, `buy_time`, `supply_id`, `place_id`, `buy_user`, `phone`, `is_in`) VALUES (55, 11, 1, 8, 8, '2024-10-28 20:09:18', 4, 3, '王五', '13666666666', '1');
COMMIT;

-- ----------------------------
-- Table structure for check_batch
-- ----------------------------
DROP TABLE IF EXISTS `check_batch`;
CREATE TABLE `check_batch` (
  `batch_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '批次id',
  `batch_num` varchar(20) DEFAULT NULL COMMENT '批总量',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `create_user` varchar(30) DEFAULT NULL COMMENT '创建的用户名',
  PRIMARY KEY (`batch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COMMENT='盘点批次表';

-- ----------------------------
-- Records of check_batch
-- ----------------------------
BEGIN;
INSERT INTO `check_batch` (`batch_id`, `batch_num`, `store_id`, `create_time`, `create_user`) VALUES (23, '201712121120', 1, '2023-12-12 11:20:30', 'admin');
INSERT INTO `check_batch` (`batch_id`, `batch_num`, `store_id`, `create_time`, `create_user`) VALUES (24, '201712121123', 1, '2023-12-12 11:23:25', 'admin');
INSERT INTO `check_batch` (`batch_id`, `batch_num`, `store_id`, `create_time`, `create_user`) VALUES (25, '201712121124', 1, '2023-12-12 11:24:01', 'admin');
INSERT INTO `check_batch` (`batch_id`, `batch_num`, `store_id`, `create_time`, `create_user`) VALUES (26, '201712121823', 1, '2023-12-12 18:23:36', 'admin');
INSERT INTO `check_batch` (`batch_id`, `batch_num`, `store_id`, `create_time`, `create_user`) VALUES (27, '201712121841', 1, '2023-12-12 18:41:47', 'admin');
INSERT INTO `check_batch` (`batch_id`, `batch_num`, `store_id`, `create_time`, `create_user`) VALUES (28, '201712141557', 1, '2023-12-14 15:57:36', 'admin');
COMMIT;

-- ----------------------------
-- Table structure for check_record
-- ----------------------------
DROP TABLE IF EXISTS `check_record`;
CREATE TABLE `check_record` (
  `record_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '记录id',
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `batch_id` int(11) DEFAULT NULL COMMENT '批次id',
  `check_state` char(1) DEFAULT '0' COMMENT '盘点状态：1 盘点完成  0 未盘点',
  PRIMARY KEY (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='盘点记录表';

-- ----------------------------
-- Records of check_record
-- ----------------------------
BEGIN;
INSERT INTO `check_record` (`record_id`, `product_id`, `store_id`, `batch_id`, `check_state`) VALUES (19, 1, 1, 23, '1');
INSERT INTO `check_record` (`record_id`, `product_id`, `store_id`, `batch_id`, `check_state`) VALUES (20, 2, 1, 24, '1');
INSERT INTO `check_record` (`record_id`, `product_id`, `store_id`, `batch_id`, `check_state`) VALUES (21, 2, 1, 25, '1');
INSERT INTO `check_record` (`record_id`, `product_id`, `store_id`, `batch_id`, `check_state`) VALUES (22, 3, 1, 26, '1');
INSERT INTO `check_record` (`record_id`, `product_id`, `store_id`, `batch_id`, `check_state`) VALUES (23, 4, 1, 27, '1');
INSERT INTO `check_record` (`record_id`, `product_id`, `store_id`, `batch_id`, `check_state`) VALUES (24, 13, 1, 28, '1');
COMMIT;

-- ----------------------------
-- Table structure for in_store
-- ----------------------------
DROP TABLE IF EXISTS `in_store`;
CREATE TABLE `in_store` (
  `ins_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '入库单id',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `in_num` int(11) DEFAULT NULL COMMENT '入库数量',
  `create_by` int(11) DEFAULT NULL COMMENT '创建用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_in` char(1) DEFAULT NULL COMMENT '入库状态：0 否 1 是',
  PRIMARY KEY (`ins_id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='入库单表';

-- ----------------------------
-- Records of in_store
-- ----------------------------
BEGIN;
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (1, 1, 1, 150, 1, '2023-12-08 14:17:02', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (2, 2, 5, 150, 1, '2023-12-08 14:17:31', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (3, 1, 1, 198, NULL, '2023-12-11 13:16:20', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (4, 1, 1, 198, NULL, '2023-12-11 13:25:32', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (5, 1, 1, 198, NULL, '2023-12-11 13:28:30', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (6, 1, 1, 198, NULL, '2023-12-11 13:36:04', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (7, 1, 1, 198, NULL, '2023-12-11 13:48:12', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (8, 1, 1, 198, 1, '2023-12-11 13:52:14', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (9, 1, 1, 198, 1, '2023-12-11 13:57:52', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (10, 1, 1, 198, 1, '2023-12-11 14:00:03', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (11, 1, 1, 198, 1, '2023-12-11 14:00:42', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (12, 1, 1, 198, 1, '2023-12-11 14:02:27', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (13, 1, 1, 198, 1, '2023-12-11 14:32:05', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (14, 1, 1, 198, 1, '2023-12-11 14:35:35', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (15, 1, 1, 198, 1, '2023-12-11 14:36:09', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (16, 1, 1, 123, 1, '2023-12-11 15:04:01', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (17, 1, 1, 200, 1, '2023-12-12 10:32:37', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (18, 1, 2, 700, 1, '2023-12-12 10:43:06', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (19, 1, 1, 700, 1, '2023-12-12 10:44:07', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (20, 1, 9, 100, 1, '2023-12-13 14:42:11', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (21, 1, 10, 21, 1, '2023-12-13 14:46:18', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (22, 1, 11, 32, 1, '2023-12-13 15:22:12', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (23, 1, 12, 11, 1, '2023-12-13 15:33:10', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (24, 1, 13, 100, 1, '2023-12-13 15:37:11', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (25, 1, 14, 222, 1, '2023-12-13 18:57:06', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (26, 1, 15, 78, 1, '2023-12-13 19:18:12', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (27, 1, 16, 100, 1, '2023-12-13 19:27:14', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (28, 1, 1, 400, 1, '2023-12-14 11:08:55', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (29, 1, 13, 300, 1, '2023-12-14 11:37:53', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (30, 1, 3, 300, 1, '2023-12-14 11:40:15', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (31, 2, 18, 43, 1, '2023-12-14 15:39:13', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (32, 1, 22, 666, 1, '2023-04-20 12:00:02', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (33, 1, 14, 10, 1, '2023-04-20 12:03:15', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (34, 1, 7, 1, 1, '2023-04-20 17:19:36', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (35, 1, 22, 50, 1, '2023-04-20 17:30:25', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (36, 1, 13, 399, 1, '2023-04-20 17:38:22', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (37, 1, 21, 6, 1, '2023-04-20 17:44:24', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (38, 1, 7, 15, 1, '2023-04-21 08:56:47', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (39, 1, 22, 50, 1, '2023-04-21 09:15:07', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (40, 1, 5, 600, 1, '2023-04-21 09:35:35', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (41, 1, 1, 33, 1, '2023-04-21 09:37:09', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (42, 1, 28, 20, 1, '2023-04-22 11:25:20', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (43, 1, 25, 15, 1, '2023-04-22 11:55:01', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (44, 1, 22, 20, 28, '2023-04-22 13:54:56', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (45, 1, 25, 80, 28, '2023-04-24 15:50:54', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (46, 1, 30, 20, 32, '2023-04-24 15:55:58', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (47, 2, 6, 30, 1, '2024-09-14 16:28:02', '0');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (48, 2, 6, 20, 1, '2024-09-18 10:39:01', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (49, 2, 6, 100, 1, '2024-09-18 14:29:03', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (50, 2, 6, 100, 1, '2024-09-18 14:33:07', '1');
INSERT INTO `in_store` (`ins_id`, `store_id`, `product_id`, `in_num`, `create_by`, `create_time`, `is_in`) VALUES (51, 1, 11, 8, 1, '2024-10-28 20:10:04', '1');
COMMIT;

-- ----------------------------
-- Table structure for login_log
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
  `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID',
  `user_name` varchar(50) DEFAULT '' COMMENT '用户账号',
  `ipaddr` varchar(128) DEFAULT '' COMMENT '登录IP地址',
  `login_location` varchar(255) DEFAULT '' COMMENT '登录地点',
  `browser` varchar(50) DEFAULT '' COMMENT '浏览器类型',
  `os` varchar(50) DEFAULT '' COMMENT '操作系统',
  `status` char(1) DEFAULT '0' COMMENT '登录状态（0成功 1失败）',
  `msg` varchar(255) DEFAULT '' COMMENT '提示消息',
  `login_time` datetime DEFAULT NULL COMMENT '访问时间',
  PRIMARY KEY (`info_id`),
  KEY `idx_sys_logininfor_s` (`status`),
  KEY `idx_sys_logininfor_lt` (`login_time`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='系统登录日志';

-- ----------------------------
-- Records of login_log
-- ----------------------------
BEGIN;
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (1, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2024-11-06 13:55:43');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (2, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '1', '验证码错误', '2024-11-06 16:21:21');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (3, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '1', '验证码错误', '2024-11-06 16:21:28');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (4, 'admasdf', '127.0.0.1', '局域网', 'Chrome', 'OSX', '1', '验证码错误', '2024-11-06 16:21:31');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (5, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2024-11-06 16:21:38');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (6, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '1', '验证码错误', '2024-11-06 16:37:54');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (7, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2024-11-06 16:37:58');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (8, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2024-11-06 17:04:50');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (9, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2025-02-07 10:24:27');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (10, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '1', '用户名或密码不正确', '2025-02-07 11:51:04');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (11, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '1', '用户名或密码不正确', '2025-02-07 11:51:12');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (12, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2025-02-07 11:51:34');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (13, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2025-02-07 12:01:34');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (14, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2025-02-07 15:04:55');
INSERT INTO `login_log` (`info_id`, `user_name`, `ipaddr`, `login_location`, `browser`, `os`, `status`, `msg`, `login_time`) VALUES (15, 'admin', '127.0.0.1', '局域网', 'Chrome', 'OSX', '0', '登录成功！', '2025-02-07 15:33:05');
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '站内信id',
  `msg_title` varchar(100) DEFAULT NULL COMMENT '栈内信标题',
  `msg_context` text COMMENT '站内信内容',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`msg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='站内信表';

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (34, '这是admin发送给root的测试信息1', '这是admin发送给root的测试信息1', '2023-12-09 23:46:20');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (35, '这是admin发送给root的测试信息2', '这是admin发送给root的测试信息2', '2023-12-09 23:46:33');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (36, '这是admin发送给root的测试信息3', '这是admin发送给root的测试信息3', '2023-12-09 23:46:47');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (37, '这是admin发送给root的测试信息4', '这是admin发送给root的测试信息4', '2023-12-09 23:47:00');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (38, '这是admin发送给root的测试信息5', '这是admin发送给root的测试信息5', '2023-12-09 23:47:12');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (39, '这是admin发送给root的测试信息6', '这是admin发送给root的测试信息6', '2023-12-09 23:47:26');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (40, '测试7', '这是admiin发送给root的测试信息7', '2023-12-10 00:09:31');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (41, '这是root发送给admin的测试信息1', '这是root发送给admin的测试信息1', '2023-12-10 00:20:00');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (42, '这是root发送给admin的测试信息2', '这是root发送给admin的测试信息2，，，1.大数据：一台传统的物理计算机不能处理的数据就称为大数据，大数据还包含：多样化，价值化。（海量的数据） 2.在思维方式方面，大数据完全颠覆了传统的思维方式：，1.大数据：一台传统的物理计算机不能处理的数据就称为大数据，大数据还包含：多样化，价值化。（海量的数据） 2.在思维方式方面，大数据完全颠覆了传统的思维方式：', '2023-12-10 16:28:30');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (43, '测试', '1.Hadoop:开源的分布式大数据处理架构（是一个能够对大量数据进行分布式处理的软件框架） 2.分布式：n台计算机同时运算（对服务器的硬件配置要求较低） 3.Hadoop：  高可靠性 			高效性 			高可扩展性 			高容错性 			成本低 			运行在Linux平台上 			支持多种编程语言 4.Hadoop核心版本：2.0	2.0版本多增加了yarn系统 5.Hadoop的核心：HDFS:分布式数据存储系统（将得到的大量数据存储在里面） 				yarn：分布式资源调度系统（因为1.0版本中没有yarn，读取的时候是直接从mapreduce中读取， 					  大量的时间都浪费在数据的查找上面，所以yarn主要解决了这个问题， 					  相当于一个缓冲区，节省了时间） 				mapreduce:分布式数据读取系统（将存在hdfs中的大量数据读取出来，当然是有价值的读取） 				flume:日志收集系统 				spark：内存计算系统（主要是针对内存进行的操作）   最快的速度精确的结果  海量数据的分布式存储：HDFS 海量数据的分布式处理：mapreduce           flume:日志收集 价值挖掘，分析：R   										云计算  云计算的概念： 	云计算实现了通过网络提供可伸缩的，廉价的分布式计算能力，用户只需要在具备网络接入条件的地     方，就可以随时随地的获得所需要的IT（数据）资源。  云计算的关键技术 	虚拟化，分布式存储，分布式计算，多租户。   Iaas 	将基础设施（计算资源和存储）作为服务出租 Paas 	类似于Iaas，但是它包括操作系统和围绕特定应用的必须的服务。 Sass 	从一个集中的系统部署软件，使之在一台本地计算机上（或从云中远程的）运行的一个模型，由于是	计量服务，Saas允许出租一个应用的程序，并计时收费。', '2023-12-10 16:34:28');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (44, 'admin---5', '测试', '2023-12-10 21:38:25');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (45, '测试3---5', '这是用户3发给用户5的测试信息1', '2023-12-11 15:00:05');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (46, '测试3----5', '这是用户3发给用户5的测试信息2', '2023-12-11 15:00:29');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (47, '测试1---5', '这是用户1发送给用户5的测试信息1', '2023-12-11 15:02:49');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (48, '测试1----5', '这是用户1发送给用户5的测试信息2', '2023-12-11 15:03:08');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (49, '测试5----3', '这是用户5发送给用户3的测试信息1', '2023-12-11 15:32:29');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (50, NULL, NULL, '2023-12-12 18:34:00');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (51, NULL, NULL, '2023-12-12 18:34:01');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (52, '测试admin-----root----1', '测试admin-----root----1', '2023-12-12 18:34:41');
INSERT INTO `message` (`msg_id`, `msg_title`, `msg_context`, `create_time`) VALUES (53, '111111', '是分不开的不仅拷贝不是的空间分布式就高不就低不vdfbgdkghjdfknvdfjkghergdkfgbdfvdfjkghdig', '2023-12-14 16:25:18');
COMMIT;

-- ----------------------------
-- Table structure for oper_log
-- ----------------------------
DROP TABLE IF EXISTS `oper_log`;
CREATE TABLE `oper_log` (
  `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键',
  `title` varchar(50) DEFAULT '' COMMENT '模块标题',
  `business_type` int(2) DEFAULT '0' COMMENT '业务类型（0其它 1新增 2修改 3删除）',
  `method` varchar(100) DEFAULT '' COMMENT '方法名称',
  `request_method` varchar(10) DEFAULT '' COMMENT '请求方式',
  `operator_type` int(1) DEFAULT '0' COMMENT '操作类别（0其它 1后台用户 2手机端用户）',
  `oper_name` varchar(50) DEFAULT '' COMMENT '操作人员',
  `oper_url` varchar(255) DEFAULT '' COMMENT '请求URL',
  `oper_ip` varchar(128) DEFAULT '' COMMENT '主机地址',
  `oper_location` varchar(255) DEFAULT '' COMMENT '操作地点',
  `oper_param` varchar(2000) DEFAULT '' COMMENT '请求参数',
  `json_result` varchar(2000) DEFAULT '' COMMENT '返回结果',
  `status` int(1) DEFAULT '0' COMMENT '操作状态（0正常 1异常）',
  `error_msg` varchar(2000) DEFAULT '' COMMENT '错误消息',
  `oper_time` datetime DEFAULT NULL COMMENT '操作时间',
  `cost_time` bigint(20) DEFAULT '0' COMMENT '消耗时间',
  PRIMARY KEY (`oper_id`),
  KEY `idx_sys_oper_log_bt` (`business_type`),
  KEY `idx_sys_oper_log_s` (`status`),
  KEY `idx_sys_oper_log_ot` (`oper_time`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COMMENT='系统操作日志';

-- ----------------------------
-- Records of oper_log
-- ----------------------------
BEGIN;
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (1, 'user', 2, 'updateState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/updateState', '127.0.0.1', '局域网', '[UserInfo(userId=3, userCode=smith, userName=史密斯, userPwd=e10adc3949ba59abbe56e057f20f883e, userType=null, userState=1, isDelete=0, createBy=1, createTime=Thu Nov 16 19:31:49 CST 2023, updateBy=1, updateTime=Thu Sep 19 16:49:09 CST 2024, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 15:32:50', 75);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (2, 'user', 2, 'updateState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/updateState', '127.0.0.1', '局域网', '[UserInfo(userId=3, userCode=smith, userName=史密斯, userPwd=e10adc3949ba59abbe56e057f20f883e, userType=null, userState=0, isDelete=0, createBy=1, createTime=Thu Nov 16 19:31:49 CST 2023, updateBy=1, updateTime=Thu Sep 19 16:49:09 CST 2024, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 15:32:51', 14);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (3, 'user', 2, 'updateState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/updateState', '127.0.0.1', '局域网', '[UserInfo(userId=6, userCode=jack, userName=杰克, userPwd=e10adc3949ba59abbe56e057f20f883e, userType=1, userState=0, isDelete=0, createBy=1, createTime=Thu Nov 16 21:36:41 CST 2023, updateBy=1, updateTime=Tue Nov 21 10:45:57 CST 2023, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 15:32:52', 13);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (4, 'user', 2, 'updateState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/updateState', '127.0.0.1', '局域网', '[UserInfo(userId=6, userCode=jack, userName=杰克, userPwd=e10adc3949ba59abbe56e057f20f883e, userType=1, userState=1, isDelete=0, createBy=1, createTime=Thu Nov 16 21:36:41 CST 2023, updateBy=1, updateTime=Tue Nov 21 10:45:57 CST 2023, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 15:32:53', 16);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (5, 'store', 2, 'updateStore', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/store/store-update', '127.0.0.1', '局域网', '[Store(storeId=4, storeName=南京仓库, storeNum=nj1, storeAddress=南京市秦淮区, concat=赵六, phone=13666666666)]', '{\"code\":200,\"success\":true,\"message\":\"仓库修改成功！\"}', 0, '', '2024-11-06 15:33:13', 13);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (6, 'role', 2, 'updateRoleState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/role/role-state-update', '127.0.0.1', '局域网', '[Role(roleId=3, roleName=普通用户, roleDesc=普通用户, roleCode=comm_manage, roleState=1, createBy=1, createTime=Tue Nov 14 16:49:12 CST 2023, updateBy=1, updateTime=Sat Mar 25 15:09:41 CST 2023, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 16:24:36', 83);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (7, 'role', 2, 'updateRoleState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/role/role-state-update', '127.0.0.1', '局域网', '[Role(roleId=2, roleName=管理员, roleDesc=管理员, roleCode=manage, roleState=1, createBy=1, createTime=Tue Nov 14 16:49:12 CST 2023, updateBy=1, updateTime=null, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 16:24:37', 16);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (8, 'role', 2, 'updateRoleState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/role/role-state-update', '127.0.0.1', '局域网', '[Role(roleId=2, roleName=管理员, roleDesc=管理员, roleCode=manage, roleState=0, createBy=1, createTime=Tue Nov 14 16:49:12 CST 2023, updateBy=1, updateTime=null, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 16:24:38', 5);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (9, 'role', 2, 'updateRoleState', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/role/role-state-update', '127.0.0.1', '局域网', '[Role(roleId=3, roleName=普通用户, roleDesc=普通用户, roleCode=comm_manage, roleState=0, createBy=1, createTime=Tue Nov 14 16:49:12 CST 2023, updateBy=1, updateTime=Sat Mar 25 15:09:41 CST 2023, getCode=admin)]', '{\"code\":200,\"success\":true,\"message\":\"修改成功！\"}', 0, '', '2024-11-06 16:24:38', 7);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (10, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@219e158a]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:29:32', 73);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (11, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@39f691a1]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:29:43', 3);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (12, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@690a99ef]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:30:50', 7);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (13, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@43662b7f]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:32:58', 63);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (14, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@382311b1]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:36:06', 10);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (15, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@5ea1f22a]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:38:44', 270);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (16, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@711d79f0]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:39:51', 10);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (17, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@1e1c6ad5]', '{\"code\":500,\"success\":false}', 1, '', '2025-02-07 10:41:53', 60);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (18, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@4e8980f8]', '{\"code\":200,\"success\":true,\"message\":\"上传成功\",\"data\":\"http://localhost:3333/warehouse/statics/2025-02-07/63194467-b47d-46e2-9bca-84f144697131.jpg\"}', 0, '', '2025-02-07 10:42:55', 121);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (19, 'user', 2, 'modifySelf', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=null, userCode=admin123, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:43:04', 9);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (20, 'user', 2, 'modifySelf', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=null, userCode=admin123, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:44:04', 15);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (21, 'user', 1, 'modifyAvatar', 'POST', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyAvatar/1', '127.0.0.1', '局域网', '[1, org.springframework.web.multipart.support.StandardMultipartHttpServletRequest$StandardMultipartFile@3f7df7b6]', '{\"code\":200,\"success\":true,\"message\":\"上传成功\",\"data\":\"http://localhost:3333/warehouse/statics/2025-02-07/1c01ccfe-705d-435a-9e74-69f0183db469.png\"}', 0, '', '2025-02-07 10:49:53', 97);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (22, 'user', 2, 'modifySelf', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin123, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:49:56', 6);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (23, 'user', 2, 'modifySelf', 'PUT', 1, 'admin123', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin12, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:51:18', 12);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (24, 'user', 2, 'modifySelf', 'PUT', 1, 'admin12', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin121, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:51:32', 11);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (25, 'user', 2, 'modifySelf', 'PUT', 1, 'admin121', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin1211, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:51:39', 10);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (26, 'user', 2, 'modifySelf', 'PUT', 1, 'admin1211', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin1, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:52:07', 7);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (27, 'user', 2, 'modifySelf', 'PUT', 1, 'admin1', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin133, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 10:52:36', 7);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (28, 'user', 2, 'modifySelf', 'PUT', 1, 'admin133', 'http://localhost:3333/warehouse/user/modifySelf', '127.0.0.1', '局域网', '[UserInfo(userId=1, userCode=admin123, userName=null, userPwd=null, userType=null, userState=null, isDelete=null, createBy=null, createTime=null, updateBy=null, updateTime=null, getCode=null, mobile=13888888888, email=admin@qq.com, avatar=null)]', '{\"code\":200,\"success\":true,\"message\":\"修改个人信息成功！\"}', 0, '', '2025-02-07 11:32:34', 18);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (29, 'user', 2, 'modifyPwd', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyPwd', '127.0.0.1', '局域网', '[UserPwdDTO(userId=1, oldPassword=1234, password=111111, repeatPassword=111111)]', '{\"code\":500,\"success\":false,\"message\":\"原密码不正确！\"}', 1, '原密码不正确！', '2025-02-07 11:51:53', 21);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (30, 'user', 2, 'modifyPwd', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyPwd', '127.0.0.1', '局域网', '[UserPwdDTO(userId=1, oldPassword=123456, password=111111, repeatPassword=111111)]', '{\"code\":200,\"success\":true,\"message\":\"修改密码成功！\"}', 0, '', '2025-02-07 11:51:59', 12);
INSERT INTO `oper_log` (`oper_id`, `title`, `business_type`, `method`, `request_method`, `operator_type`, `oper_name`, `oper_url`, `oper_ip`, `oper_location`, `oper_param`, `json_result`, `status`, `error_msg`, `oper_time`, `cost_time`) VALUES (31, 'user', 2, 'modifyPwd', 'PUT', 1, 'admin', 'http://localhost:3333/warehouse/user/modifyPwd', '127.0.0.1', '局域网', '[UserPwdDTO(userId=1, oldPassword=111111, password=123456, repeatPassword=123456)]', '{\"code\":200,\"success\":true,\"message\":\"修改密码成功！\"}', 0, '', '2025-02-07 11:52:08', 18);
COMMIT;

-- ----------------------------
-- Table structure for out_store
-- ----------------------------
DROP TABLE IF EXISTS `out_store`;
CREATE TABLE `out_store` (
  `outs_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '出库单id',
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `tally_id` int(11) DEFAULT NULL COMMENT '理货员id',
  `out_price` decimal(8,2) DEFAULT NULL COMMENT '出库价格',
  `out_num` int(11) DEFAULT NULL COMMENT '出库数量',
  `create_by` int(11) DEFAULT NULL COMMENT '创建用户id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `is_out` char(1) DEFAULT NULL COMMENT '出库状态：0 否 1 是',
  PRIMARY KEY (`outs_id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='出库单表';

-- ----------------------------
-- Records of out_store
-- ----------------------------
BEGIN;
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (1, 1, 1, 3, NULL, 100, 1, '2023-12-08 14:18:08', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (2, 5, 1, 3, NULL, 160, 1, '2023-12-11 08:56:07', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (3, 11, 2, 3, NULL, 200, 1, '2023-12-11 08:56:15', '0');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (4, 6, 1, 3, NULL, 270, 3, '2023-12-11 08:56:29', '0');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (5, 7, 1, 3, NULL, 450, 3, '2023-12-11 08:56:36', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (6, 12, 1, 3, NULL, 340, 5, '2023-02-11 08:56:44', '0');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (7, 13, 1, 3, NULL, 120, 5, '2023-12-11 08:57:10', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (8, 14, 1, 23, NULL, 800, 5, '2023-12-12 10:47:43', '0');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (9, 19, 1, 3, NULL, 300, 10, '2023-12-14 11:43:55', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (10, 21, 1, 23, NULL, 30, 1, '2023-04-20 16:41:47', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (11, 22, 1, 23, NULL, 20, 1, '2023-04-20 16:45:41', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (12, 23, 1, 23, NULL, 15, 1, '2023-04-20 16:46:56', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (13, 25, 1, NULL, NULL, 23, 1, '2023-04-24 15:53:17', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (14, 6, 2, 1, 5.50, 50, 1, '2023-12-12 11:16:45', '1');
INSERT INTO `out_store` (`outs_id`, `product_id`, `store_id`, `tally_id`, `out_price`, `out_num`, `create_by`, `create_time`, `is_out`) VALUES (15, 6, 2, 1, 5.50, 50, 1, '2023-12-12 11:16:45', '1');
COMMIT;

-- ----------------------------
-- Table structure for place
-- ----------------------------
DROP TABLE IF EXISTS `place`;
CREATE TABLE `place` (
  `place_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '产地id',
  `place_name` varchar(200) DEFAULT NULL COMMENT '产地名',
  `place_num` varchar(20) DEFAULT NULL COMMENT '产地代码',
  `introduce` varchar(300) DEFAULT NULL COMMENT '产地介绍',
  `is_delete` char(1) DEFAULT '0' COMMENT '删除状态：0:可用  1:不可用',
  PRIMARY KEY (`place_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='产地表';

-- ----------------------------
-- Records of place
-- ----------------------------
BEGIN;
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (1, '湖南', 'hunan', '湖南挺好的啊123123123', '0');
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (2, '湖北', 'hubei', '湖北没有湖南好', '0');
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (3, '陕西', 'shanxi', '还是陕西更好', '0');
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (4, '浙江', 'zhejiang', '好地方', '0');
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (5, '山东', 'shandong', '很好', '0');
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (6, '广东', 'guangdong', '非常好', '0');
INSERT INTO `place` (`place_id`, `place_name`, `place_num`, `introduce`, `is_delete`) VALUES (7, '江苏', 'jiangsu', '江苏是个好地方', '0');
COMMIT;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `product_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `brand_id` int(11) DEFAULT NULL COMMENT '品牌id',
  `product_name` varchar(200) DEFAULT NULL COMMENT '商品名',
  `product_num` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `product_invent` int(11) DEFAULT NULL COMMENT '库存量',
  `type_id` int(11) DEFAULT NULL COMMENT '商品分类id',
  `supply_id` int(11) DEFAULT NULL COMMENT '供应商id',
  `place_id` int(11) DEFAULT NULL COMMENT '产地id',
  `unit_id` int(11) DEFAULT NULL COMMENT '规格单位id',
  `introduce` longtext COMMENT '商品介绍',
  `up_down_state` char(1) DEFAULT NULL COMMENT '上下架状态：0 下架 1 上架',
  `in_price` decimal(10,2) DEFAULT NULL COMMENT '入库价格',
  `sale_price` decimal(10,2) DEFAULT NULL COMMENT '售价',
  `mem_price` decimal(10,2) DEFAULT NULL COMMENT '会员价',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `create_by` int(11) DEFAULT NULL COMMENT '创建人id',
  `update_by` int(11) DEFAULT NULL COMMENT '更新人id',
  `imgs` varchar(500) DEFAULT NULL COMMENT '商品图片',
  `product_date` datetime DEFAULT NULL COMMENT '生产日期',
  `supp_date` datetime DEFAULT NULL COMMENT '保质期',
  `threshold` int(11) DEFAULT NULL COMMENT '阈值',
  PRIMARY KEY (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COMMENT='商品表';

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (1, 1, 3, '海尔电视d1-1111', 'haier1001', 319, 3, 4, 5, 6, '43242342342343', '1', 3899.00, 4999.00, 4599.00, '2023-12-06 12:09:12', '2024-09-19 10:02:06', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-18/a1487678-bc5a-4a19-a030-74efb04559d9.jpg', '2016-02-22 00:00:00', '2028-10-11 00:00:00', 2);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (5, 2, 3, '海尔洗衣机h1-1131', 'haierh11132', 5, 2, 2, 3, 6, 'weqweqweqwe', '0', 3899.00, 4999.00, 4599.00, '2023-12-06 12:09:12', '2024-09-19 09:08:37', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/d0fb9133-a3ed-41a4-9471-56e1cd956a32.png', '2016-02-23 00:00:00', '2024-11-02 00:00:00', 10);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (6, 2, 1, '香蕉', 'xj456', 80, 6, 2, 4, 3, '香蕉啊222', '1', 2.50, 5.50, 3.50, '2023-12-12 11:16:45', '2024-09-19 10:02:07', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-18/00d33d68-be24-4a76-8b49-98fddbaadc10.png', '2023-12-19 00:00:00', '2023-12-31 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (7, 1, 3, '海尔洗衣机h1-1132', 'haier1002', 101, 2, 4, 5, 6, 'weqweqweqwe', '1', 3899.00, 4999.00, 4599.00, '2023-12-06 12:09:12', '2024-09-19 10:02:10', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/955a99e1-fbb6-4999-871c-b4359dfb5c51.jpg', '2016-02-22 00:00:00', '2030-09-17 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (11, 1, 3, '海尔洗衣机h1-1136', 'haier1003', 8, 2, 4, 3, 6, '洗的很干净', '0', 3899.00, 4999.00, 4599.00, '2023-12-06 12:09:12', '2024-09-19 09:09:20', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/73ba8578-d7ba-4693-be0c-8136495214f1.png', '2023-10-22 00:00:00', '2024-10-31 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (12, 1, 2, '美的空调m1137', 'm1137', 3, 7, 5, 3, 6, 'weqweqweqwe', '0', 3899.00, 4999.00, 4599.00, '2023-12-06 12:09:12', '2024-09-19 09:16:53', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/444ce79f-f5fe-4ef1-89fd-b079c045cb39.jpg', '2016-02-22 00:00:00', '2023-02-22 00:00:00', 20);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (13, 2, 1, '西瓜', 'xigua', 80, 6, 1, 2, 2, '不好吃，别买了', '1', 2.50, 20.50, 8.50, '2023-12-14 10:39:14', '2024-09-19 10:02:12', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/c1fb34f3-8c9b-42e2-bf9b-0d6209bf032a.png', '2023-12-10 00:00:00', '2027-12-19 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (14, 2, 4, '华为电视h1138', 'huawei1138', 3, 3, 6, 4, 6, '华为电视好啊', '0', 3899.00, 4999.00, 4599.00, '2023-12-06 12:09:12', '2023-12-14 09:42:24', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/be3e7818-a663-45dc-94c0-05e01f34a6cf.png', '2023-12-31 00:00:00', '2029-09-23 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (19, 2, 1, '西瓜3号', 'xg9527', 2000, 6, 2, 3, 2, '皮薄保甜', '1', 3.00, 5.00, 4.00, '2023-04-08 11:19:38', '2024-09-19 10:02:14', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/d2bac429-c041-4d89-aec2-5fdb5c738f16.png', '2023-04-09 00:00:00', '2023-04-30 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (21, 1, 1, '印度香蕉', 'xg123', 270, 6, 2, 4, 3, '香蕉啊', '0', 2.50, 5.50, 3.50, '2023-04-08 11:58:47', '2023-04-08 15:11:48', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/417403e7-a84c-4d78-9cec-b0d4be18832b.png', '2023-12-19 00:00:00', '2023-12-29 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (22, 1, 2, '空调', 'midea1001', 170, 7, 5, 6, 6, '很凉快', '1', 2000.00, 3999.00, 3699.00, '2023-04-08 15:39:56', '2024-09-19 10:02:18', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/9d2ca748-e7f5-4aba-b6a8-44a65549b075.png', '2023-03-24 00:00:00', '2034-12-20 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (23, 2, 2, '风扇', 'midea1002', 980, 8, 5, 6, 6, '没有风，只有声。。。', '1', 100.00, 299.00, 249.00, '2023-04-08 15:44:22', '2024-09-19 10:02:16', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/19e9b16c-d740-49db-a66d-b5989109b4ea.png', '2023-04-01 00:00:00', '2038-09-15 00:00:00', 5);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (24, 2, 1, '香蕉', 'xg124', 0, 6, 2, 4, 3, '香蕉啊', '0', 2.50, 5.50, 3.50, '2023-04-08 11:58:47', '2023-04-08 15:11:48', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/89681dd4-d13f-42b0-b408-4d681bfc5f1a.png', '2023-12-19 00:00:00', '2023-12-29 00:00:00', 6);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (25, 1, 2, '风扇', 'midea1004', 7, 8, 5, 6, 6, '没有风，只有声。。。', '0', 100.00, 299.00, 249.00, '2023-04-08 15:44:22', '2024-09-19 09:16:25', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/c8b764ea-d6ee-4a52-a511-e35f7c269dde.png', '2023-04-01 00:00:00', '2038-09-15 00:00:00', 10);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (27, 1, 1, '西瓜2号', 'xg9528', 100, 6, 2, 3, 2, '皮薄保甜', '0', 3.00, 5.00, 4.00, '2023-04-08 11:19:38', '2023-04-24 15:48:59', 1, 31, 'http://localhost:3333/warehouse/statics/2024-09-19/2002e4ca-d2bc-48cf-bf32-bd3c69e0b4e8.png', '2023-04-09 00:00:00', '2023-06-05 00:00:00', 8);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (28, 3, 1, ' 无籽麒麟大西瓜', 'xigua6', 220, 6, 1, 2, 2, '无籽麒麟大西瓜1粒装 7-9斤 生鲜水果', '0', 2.50, 20.50, 8.50, '2023-12-14 10:39:14', '2023-04-24 16:02:49', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/0f71e6d6-50d9-4757-86da-a78c21e9d032.png', '2023-12-09 00:00:00', '2027-12-18 00:00:00', 8);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (29, 3, 4, '华为Mate 60 Pro', 'huawei_mate60_1', 30, 12, 6, 3, 6, '高端大气上档次', '1', 2000.00, 5999.00, 5699.00, '2023-04-24 15:43:05', '2024-09-19 10:02:21', 31, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/1e967e7b-14f6-43a2-8466-0f9b15e08fbf.png', '2023-03-17 00:00:00', '2042-07-24 00:00:00', 8);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (30, 1, 2, '桌面小风扇', 'midea1003', 20, 8, 5, 6, 6, '没有风，只有声。。。', '0', 100.00, 299.00, 249.00, '2023-04-08 15:44:22', '2024-09-19 09:52:44', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/794f1c0e-2158-424a-b31f-b3e0c073649f.png', '2023-04-01 00:00:00', '2038-09-15 00:00:00', 7);
INSERT INTO `product` (`product_id`, `store_id`, `brand_id`, `product_name`, `product_num`, `product_invent`, `type_id`, `supply_id`, `place_id`, `unit_id`, `introduce`, `up_down_state`, `in_price`, `sale_price`, `mem_price`, `create_time`, `update_time`, `create_by`, `update_by`, `imgs`, `product_date`, `supp_date`, `threshold`) VALUES (32, 2, 1, '西红柿', 'tomato_101', 10, 5, 2, 2, 2, '山东西红柿 净重1.5kg 自然熟番茄新鲜水果蔬菜', '1', 10.00, 30.00, 20.00, '2024-09-18 11:46:50', '2024-09-19 10:02:22', 1, 1, 'http://localhost:3333/warehouse/statics/2024-09-19/8eaf3534-8509-4fa8-a49b-dd8d179a4d9b.png', '2024-09-15 00:00:00', '2024-10-30 00:00:00', 20);
COMMIT;

-- ----------------------------
-- Table structure for product_type
-- ----------------------------
DROP TABLE IF EXISTS `product_type`;
CREATE TABLE `product_type` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品分类id',
  `parent_id` int(11) DEFAULT NULL COMMENT '父类id，为0时为顶级分类',
  `type_code` varchar(50) DEFAULT NULL COMMENT '分类代码',
  `type_name` varchar(100) DEFAULT NULL COMMENT '分类名',
  `type_desc` varchar(300) DEFAULT NULL COMMENT '分类描述',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='商品分类表';

-- ----------------------------
-- Records of product_type
-- ----------------------------
BEGIN;
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (1, 0, 'appliance', '家电类', '种类齐全，货源充足');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (2, 1, 'washer', '洗衣机', '全是洗衣机啊~~');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (3, 1, 'televison', '电视机', '全是电视机啊~~');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (4, 0, 'fruit-vegetable', '果蔬类', '全是果蔬啊~~');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (5, 4, 'vegetable', '蔬菜', '全是蔬菜啊~~');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (6, 4, 'fruit', '水果', '全是水果啊~~');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (7, 1, 'air-condition', '空调', '很凉快');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (8, 1, 'blower', '风扇', '也很凉快');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (11, 0, 'phone', '手机', '大家都机不离手');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (12, 11, 'huawei', '华为手机', '中华有为');
INSERT INTO `product_type` (`type_id`, `parent_id`, `type_code`, `type_name`, `type_desc`) VALUES (13, 11, 'apple', '苹果手机', '一般般，小心被定位');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `role_name` varchar(100) DEFAULT NULL COMMENT '角色名',
  `role_desc` varchar(300) DEFAULT NULL COMMENT '角色描述',
  `role_code` varchar(100) DEFAULT NULL COMMENT '角色代码',
  `role_state` char(1) DEFAULT NULL COMMENT '角色状态：1 启用 0 禁用',
  `create_by` int(11) DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` int(11) DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (1, '超级管理员', '超级管理员', 'supper_manage', '1', 1, '2023-11-14 16:49:12', 1, '2023-11-14 16:49:20');
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (2, '管理员', '管理员', 'manage', '0', 1, '2023-11-14 16:49:12', 1, NULL);
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (3, '普通用户', '普通用户', 'comm_manage', '0', 1, '2023-11-14 16:49:12', 1, '2023-03-25 15:09:41');
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (11, '采购员', '采购管理员', 'purchase_man', '1', 1, '2023-04-22 12:29:00', 1, '2023-04-22 13:56:29');
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (12, '入库员', '入库管理员', 'in_store', '1', 1, '2023-04-22 13:56:17', NULL, NULL);
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (13, '商品管理员', '商品管理员', 'commodity_manager', '1', 1, '2023-04-22 13:57:42', NULL, NULL);
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (14, '出库员', '出库管理员', 'out_store', '1', 1, '2023-04-22 14:00:00', NULL, NULL);
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (15, '调货员', '调货管理员', 'transshipment_manager', '1', 1, '2023-04-22 14:00:38', NULL, NULL);
INSERT INTO `role` (`role_id`, `role_name`, `role_desc`, `role_code`, `role_state`, `create_by`, `create_time`, `update_by`, `update_time`) VALUES (16, '仓库管理员', '仓库管理员', 'store_manager', '1', 1, '2023-04-24 15:12:56', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for role_auth
-- ----------------------------
DROP TABLE IF EXISTS `role_auth`;
CREATE TABLE `role_auth` (
  `role_auth_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色权限id',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `auth_id` int(11) DEFAULT NULL COMMENT '权限id',
  PRIMARY KEY (`role_auth_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1281 DEFAULT CHARSET=utf8 COMMENT='角色权限表';

-- ----------------------------
-- Records of role_auth
-- ----------------------------
BEGIN;
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (118, 4, 1);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (119, 4, 2);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (120, 4, 3);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (121, 4, 10);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (122, 4, 23);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (123, 4, 24);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (124, 4, 35);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (125, 4, 36);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (126, 4, 4);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (127, 4, 5);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (128, 4, 6);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (129, 4, 27);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (130, 4, 28);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (131, 4, 7);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (132, 4, 8);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (133, 4, 9);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (134, 5, 1);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (135, 5, 2);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (136, 5, 3);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (137, 5, 10);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (138, 8, 1);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (139, 8, 2);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (140, 8, 3);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (141, 8, 10);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (142, 8, 23);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (143, 8, 24);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (535, 2, 1);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (536, 2, 2);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (537, 2, 3);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (538, 2, 10);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (539, 2, 23);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (540, 2, 24);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (541, 2, 25);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (542, 2, 26);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (543, 2, 35);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (544, 2, 36);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (545, 2, 4);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (546, 2, 5);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (547, 2, 6);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (548, 2, 27);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (549, 2, 28);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (550, 2, 30);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (551, 2, 31);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (552, 2, 37);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (553, 2, 7);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (554, 2, 8);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (555, 2, 9);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (556, 2, 32);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (557, 2, 33);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (558, 2, 34);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (559, 2, 20);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (560, 2, 21);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (561, 2, 22);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (562, 3, 23);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (563, 3, 36);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (694, 16, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (695, 16, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (696, 16, 69);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (697, 16, 70);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (698, 11, 42);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (699, 11, 50);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (700, 11, 92);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (701, 11, 93);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (702, 11, 94);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (703, 11, 97);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (704, 11, 76);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (705, 11, 53);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (706, 11, 56);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (707, 11, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (708, 11, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (709, 12, 54);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (710, 12, 57);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (711, 12, 95);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (712, 12, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (713, 12, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (714, 13, 42);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (715, 13, 50);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (716, 13, 92);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (717, 13, 93);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (718, 13, 94);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (719, 13, 97);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (720, 13, 76);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (721, 13, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (722, 13, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (723, 14, 42);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (724, 14, 50);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (725, 14, 92);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (726, 14, 93);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (727, 14, 94);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (728, 14, 97);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (729, 14, 76);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (730, 14, 55);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (731, 14, 58);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (732, 14, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (733, 14, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (734, 15, 42);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (735, 15, 50);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (736, 15, 92);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (737, 15, 93);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (738, 15, 94);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (739, 15, 97);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (740, 15, 76);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (741, 15, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (742, 15, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (743, 15, 68);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (744, 15, 71);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (745, 15, 96);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1213, 1, 100);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1214, 1, 101);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1215, 1, 1);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1216, 1, 2);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1217, 1, 3);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1218, 1, 10);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1219, 1, 23);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1220, 1, 24);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1221, 1, 25);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1222, 1, 26);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1223, 1, 35);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1224, 1, 36);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1225, 1, 4);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1226, 1, 5);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1227, 1, 6);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1228, 1, 27);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1229, 1, 28);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1230, 1, 30);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1231, 1, 31);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1232, 1, 37);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1233, 1, 7);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1234, 1, 8);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1235, 1, 9);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1236, 1, 32);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1237, 1, 33);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1238, 1, 34);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1239, 1, 42);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1240, 1, 50);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1241, 1, 92);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1242, 1, 93);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1243, 1, 94);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1244, 1, 97);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1245, 1, 76);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1246, 1, 53);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1247, 1, 56);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1248, 1, 54);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1249, 1, 57);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1250, 1, 95);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1251, 1, 55);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1252, 1, 58);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1253, 1, 68);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1254, 1, 99);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1255, 1, 71);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1256, 1, 96);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1257, 1, 69);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1258, 1, 70);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1259, 1, 74);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1260, 1, 75);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1261, 1, 19);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1262, 1, 20);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1263, 1, 21);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1264, 1, 22);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1265, 1, 38);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1266, 1, 43);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1267, 1, 44);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1268, 1, 41);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1269, 1, 46);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1270, 1, 61);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1271, 1, 62);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1272, 1, 63);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1273, 1, 64);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1274, 1, 98);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1275, 1, 65);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1276, 1, 66);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1277, 1, 67);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1278, 1, 102);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1279, 1, 103);
INSERT INTO `role_auth` (`role_auth_id`, `role_id`, `auth_id`) VALUES (1280, 1, 104);
COMMIT;

-- ----------------------------
-- Table structure for store
-- ----------------------------
DROP TABLE IF EXISTS `store`;
CREATE TABLE `store` (
  `store_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '仓库id',
  `store_name` varchar(100) DEFAULT NULL COMMENT '仓库名',
  `store_num` varchar(20) DEFAULT NULL COMMENT '仓库代码',
  `store_address` varchar(100) DEFAULT NULL COMMENT '仓库地址',
  `concat` varchar(50) DEFAULT NULL COMMENT '联系人',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系人电话',
  PRIMARY KEY (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='仓库表';

-- ----------------------------
-- Records of store
-- ----------------------------
BEGIN;
INSERT INTO `store` (`store_id`, `store_name`, `store_num`, `store_address`, `concat`, `phone`) VALUES (1, '西安仓库', 'xa1', '西安市雁塔区', '张三', '13829086629');
INSERT INTO `store` (`store_id`, `store_name`, `store_num`, `store_address`, `concat`, `phone`) VALUES (2, '北京仓库', 'bj2', '北京市朝阳区 ', '王麻子', '15229267291');
INSERT INTO `store` (`store_id`, `store_name`, `store_num`, `store_address`, `concat`, `phone`) VALUES (3, '上海仓库', 'sh3', '上海市浦东区', '李四', '18092647320');
INSERT INTO `store` (`store_id`, `store_name`, `store_num`, `store_address`, `concat`, `phone`) VALUES (4, '南京仓库', 'nj1', '南京市秦淮区', '赵六', '13666666666');
COMMIT;

-- ----------------------------
-- Table structure for store_check
-- ----------------------------
DROP TABLE IF EXISTS `store_check`;
CREATE TABLE `store_check` (
  `check_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '盘点id',
  `store_id` int(11) DEFAULT NULL COMMENT '仓库id',
  `record_id` int(11) NOT NULL COMMENT '记录id',
  `product_id` int(11) DEFAULT NULL COMMENT '商品id',
  `batch_id` int(11) DEFAULT NULL COMMENT '批次id',
  `check_num` decimal(8,2) DEFAULT NULL COMMENT '盘点商品数',
  `check_time` date DEFAULT NULL COMMENT '盘点日期',
  `check_user` varchar(20) DEFAULT NULL COMMENT '盘点负责人',
  `loss_num` decimal(8,2) DEFAULT NULL COMMENT '损失商品数',
  `reson` varchar(200) DEFAULT '0' COMMENT '盘点损失的原因',
  PRIMARY KEY (`check_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='盘点表';

-- ----------------------------
-- Records of store_check
-- ----------------------------
BEGIN;
INSERT INTO `store_check` (`check_id`, `store_id`, `record_id`, `product_id`, `batch_id`, `check_num`, `check_time`, `check_user`, `loss_num`, `reson`) VALUES (21, 1, 19, 1, 23, 12.00, '2023-12-12', 'r', 1.00, 'sunaho');
INSERT INTO `store_check` (`check_id`, `store_id`, `record_id`, `product_id`, `batch_id`, `check_num`, `check_time`, `check_user`, `loss_num`, `reson`) VALUES (22, 1, 20, 2, 24, NULL, '2023-12-12', '', 1.00, '');
INSERT INTO `store_check` (`check_id`, `store_id`, `record_id`, `product_id`, `batch_id`, `check_num`, `check_time`, `check_user`, `loss_num`, `reson`) VALUES (23, 1, 21, 2, 25, 123.00, '2023-12-12', 'xxxxxx', 1.00, 'xxx');
INSERT INTO `store_check` (`check_id`, `store_id`, `record_id`, `product_id`, `batch_id`, `check_num`, `check_time`, `check_user`, `loss_num`, `reson`) VALUES (24, 1, 22, 3, 26, 111111.00, '2023-12-12', 'frfrfrfr', 1.00, 'frfrfrfr');
INSERT INTO `store_check` (`check_id`, `store_id`, `record_id`, `product_id`, `batch_id`, `check_num`, `check_time`, `check_user`, `loss_num`, `reson`) VALUES (25, 1, 23, 4, 27, 123.00, '2023-11-12', 'r', 1.00, 'frfr');
INSERT INTO `store_check` (`check_id`, `store_id`, `record_id`, `product_id`, `batch_id`, `check_num`, `check_time`, `check_user`, `loss_num`, `reson`) VALUES (26, 1, 24, 13, 28, 12.00, '2023-11-14', '杜', 1.00, 'sunhao');
COMMIT;

-- ----------------------------
-- Table structure for supply
-- ----------------------------
DROP TABLE IF EXISTS `supply`;
CREATE TABLE `supply` (
  `supply_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '供应商id',
  `supply_num` varchar(20) DEFAULT NULL COMMENT '供应商代码',
  `supply_name` varchar(100) DEFAULT NULL COMMENT '供应商名',
  `supply_introduce` longtext COMMENT '供应商介绍',
  `concat` varchar(50) DEFAULT NULL COMMENT '联系人',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系人手机号',
  `address` varchar(100) DEFAULT NULL COMMENT '供应商所在地',
  `is_delete` char(1) DEFAULT '0' COMMENT '删除状态：0 正常、 1 已删除',
  PRIMARY KEY (`supply_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='供货商表';

-- ----------------------------
-- Records of supply
-- ----------------------------
BEGIN;
INSERT INTO `supply` (`supply_id`, `supply_num`, `supply_name`, `supply_introduce`, `concat`, `phone`, `address`, `is_delete`) VALUES (1, 'zjsh', '浙江三禾竹木有限公司', '贷款是否会为加快和规范健康环境如何根据', '任伟', '15287653921', '浙江省丽水市', '0');
INSERT INTO `supply` (`supply_id`, `supply_num`, `supply_name`, `supply_introduce`, `concat`, `phone`, `address`, `is_delete`) VALUES (2, 'lqlo', '龙泉绿欧食品有限公司', NULL, '张三', '18134532830', '浙江省龙泉市', '0');
INSERT INTO `supply` (`supply_id`, `supply_num`, `supply_name`, `supply_introduce`, `concat`, `phone`, `address`, `is_delete`) VALUES (3, 'dhgy', '帝豪供应链公司', NULL, '李四', '17493976543', '陕西省西安市', '0');
INSERT INTO `supply` (`supply_id`, `supply_num`, `supply_name`, `supply_introduce`, `concat`, `phone`, `address`, `is_delete`) VALUES (4, 'haier', '海尔集团', '海尔智家为用户提供衣、食、住、娱的智慧全场景解决方案，全面提升用户生活品质，以“云”体验、全链路服务、个性化智慧终端，实现交互、体验、销售、服务于一体的全流程生态平台。', '周云杰', '4006999511', '山东省青岛市', '0');
INSERT INTO `supply` (`supply_id`, `supply_num`, `supply_name`, `supply_introduce`, `concat`, `phone`, `address`, `is_delete`) VALUES (5, 'midea', '美的集团股份有限公司', '科技尽善，生活尽美”– 美的集团秉承用科技创造美好生活的经营理念，如今已成为一家集智能家居事业群、机电事业群、暖通与楼宇事业部、机器人及自动化事业部、数字化创新业务五大板块为一体的全球化科技集团，产品及服务惠及全球200多个国家和地区约4亿用户。形成美的、小天鹅、东芝、华凌、布谷、COLMO、Clivet、Eureka、库卡、GMCC、威灵在内的多品牌组合。', '方洪波', '075726338788', '广东省佛山市', '0');
INSERT INTO `supply` (`supply_id`, `supply_num`, `supply_name`, `supply_introduce`, `concat`, `phone`, `address`, `is_delete`) VALUES (6, 'huawei', '华为技术有限公司', '华为技术有限公司，成立于1987年，总部位于中国广东省深圳市龙岗区坂田华为基地。', '任正非', '13777777777', '广东省深圳市龙岗区坂田华为总部办公楼‌', '0');
COMMIT;

-- ----------------------------
-- Table structure for transshipment
-- ----------------------------
DROP TABLE IF EXISTS `transshipment`;
CREATE TABLE `transshipment` (
  `trans_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '调货单id',
  `source_store_id` int(11) DEFAULT NULL COMMENT '源仓库id',
  `source_product_id` int(11) DEFAULT NULL COMMENT '源商品id',
  `target_store_id` int(11) DEFAULT NULL COMMENT '目标仓库id',
  `target_product_id` int(11) DEFAULT NULL COMMENT '目标商品id',
  `trans_num` int(11) DEFAULT NULL COMMENT '调货量',
  `audit_state` char(1) DEFAULT NULL COMMENT '审核状态：0 未审核 1 已审核',
  `create_by` int(11) DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`trans_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='调货单表';

-- ----------------------------
-- Records of transshipment
-- ----------------------------
BEGIN;
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (1, 2, 5, 1, 9, 100, '1', 1, '2023-12-13 14:42:01');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (2, 2, 5, 1, 10, 21, '1', 1, '2023-12-13 14:46:16');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (3, 2, 5, 1, 11, 32, '1', 1, '2023-12-13 15:22:04');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (4, 2, 5, 1, 12, 11, '1', 1, '2023-12-13 15:33:08');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (5, 2, 6, 1, 13, 100, '1', 1, '2023-12-13 15:37:03');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (6, 2, 6, 1, 14, 222, '1', 1, '2023-12-13 18:57:03');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (7, 2, 6, 1, 15, 78, '1', 1, '2023-12-13 19:17:59');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (8, 2, 6, 1, 16, 100, '1', 1, '2023-12-13 19:27:11');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (9, 1, 1, 2, 18, 43, '1', 1, '2023-12-14 15:39:04');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (10, 1, 21, 2, 24, 20, '0', 1, '2023-04-21 20:47:36');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (11, 2, 23, 1, 25, 100, '0', 1, '2023-04-21 21:01:24');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (12, 2, 13, 1, 26, 20, '0', 1, '2023-04-22 09:02:29');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (13, 2, 19, 1, 27, 20, '0', 1, '2023-04-22 09:16:57');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (14, 2, 13, 1, 28, 20, '1', 1, '2023-04-22 09:17:30');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (15, 2, 23, 1, 30, 20, '1', 32, '2023-04-24 15:55:47');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (16, 2, 6, NULL, NULL, 10, '0', 1, '2024-09-18 17:01:01');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (17, 2, 6, NULL, NULL, 10, '0', 1, '2024-09-18 17:21:43');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (18, 2, 6, 3, NULL, 10, '0', 1, '2024-09-18 17:39:14');
INSERT INTO `transshipment` (`trans_id`, `source_store_id`, `source_product_id`, `target_store_id`, `target_product_id`, `trans_num`, `audit_state`, `create_by`, `create_time`) VALUES (19, 2, 6, 1, 6, 20, '0', 1, '2024-09-18 17:42:03');
COMMIT;

-- ----------------------------
-- Table structure for unit
-- ----------------------------
DROP TABLE IF EXISTS `unit`;
CREATE TABLE `unit` (
  `unit_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '规格单位id',
  `unit_name` varchar(20) DEFAULT NULL COMMENT '规格单位名',
  `unit_desc` varchar(20) DEFAULT NULL COMMENT '规格单位描述',
  PRIMARY KEY (`unit_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='规格单位表';

-- ----------------------------
-- Records of unit
-- ----------------------------
BEGIN;
INSERT INTO `unit` (`unit_id`, `unit_name`, `unit_desc`) VALUES (1, '箱/件', '箱/件');
INSERT INTO `unit` (`unit_id`, `unit_name`, `unit_desc`) VALUES (2, '个', '个');
INSERT INTO `unit` (`unit_id`, `unit_name`, `unit_desc`) VALUES (3, '公斤', '公斤');
INSERT INTO `unit` (`unit_id`, `unit_name`, `unit_desc`) VALUES (4, '只', '只');
INSERT INTO `unit` (`unit_id`, `unit_name`, `unit_desc`) VALUES (5, '克', '克');
INSERT INTO `unit` (`unit_id`, `unit_name`, `unit_desc`) VALUES (6, '台', '台');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `user_code` varchar(50) DEFAULT NULL COMMENT '用户名',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户昵称(姓名)',
  `user_pwd` varchar(100) DEFAULT NULL COMMENT '用户密码',
  `user_type` char(1) DEFAULT NULL COMMENT '用户类型',
  `user_state` char(1) DEFAULT NULL COMMENT '用户状态:0 禁用 、1 启用',
  `is_delete` char(1) DEFAULT NULL COMMENT '删除状态：0 正常、 1 已删除',
  `create_by` int(11) DEFAULT NULL COMMENT '创建人id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_by` int(11) DEFAULT NULL COMMENT '更新人id',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `mobile` varchar(255) DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (1, 'admin', '超级管理员', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-11-14 15:14:31', 1, '2025-02-07 11:52:08', '13888888888', 'admin@qq.com', 'http://localhost:3333/warehouse/statics/2025-02-07/1c01ccfe-705d-435a-9e74-69f0183db469.png');
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (3, 'smith', '史密斯', 'e10adc3949ba59abbe56e057f20f883e', NULL, '0', '0', 1, '2023-11-16 19:31:49', 1, '2024-09-19 16:49:09', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (5, 'tom', '汤姆', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-11-16 21:25:41', 1, '2023-03-15 14:57:44', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (6, 'jack', '杰克', 'e10adc3949ba59abbe56e057f20f883e', '1', '1', '0', 1, '2023-11-16 21:36:41', 1, '2023-11-21 10:45:57', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (7, 'mike', '麦克', 'e10adc3949ba59abbe56e057f20f883e', '1', '0', '0', 1, '2023-11-16 21:39:09', 1, '2023-11-21 10:44:35', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (10, 'alice', '爱丽丝', 'e10adc3949ba59abbe56e057f20f883e', '3', '0', '1', 1, '2023-11-17 10:48:24', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (19, 'lucy', '露西', 'e10adc3949ba59abbe56e057f20f883e', '2', '0', '0', 1, '2023-11-29 22:10:51', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (20, 'liuyi', '刘一', 'e10adc3949ba59abbe56e057f20f883e', '2', '1', '1', 1, '2023-12-01 14:40:15', 1, '2024-09-19 17:07:19', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (21, 'chener', '陈二', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-03-17 17:24:00', 1, '2024-09-19 16:50:15', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (23, 'zhangsan', '张三', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-04-08 16:18:52', 1, '2024-09-19 17:15:15', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (24, 'lisi', '李四', 'e10adc3949ba59abbe56e057f20f883e', NULL, '0', '0', 1, '2023-04-08 16:20:19', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (25, 'wangwu', '王五', 'e10adc3949ba59abbe56e057f20f883e', NULL, '0', '1', 1, '2023-04-08 16:20:43', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (26, 'liuliu', '刘六', 'e10adc3949ba59abbe56e057f20f883e', NULL, '0', '0', 1, '2023-04-08 16:21:14', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (27, 'qiaoqi', '乔七', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '1', 1, '2023-04-19 17:09:13', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (28, 'aaa', 'aaa', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-04-22 13:42:35', 1, '2024-09-19 16:49:05', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (29, 'bbb', 'bbb', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-04-22 13:50:25', 1, '2024-09-19 16:49:04', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (30, 'ccc', 'ccc', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-04-22 13:53:20', 1, '2024-09-19 16:49:03', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (31, 'ddd', 'ddd', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-04-22 13:57:11', 1, '2024-09-19 16:48:50', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (32, 'eee', 'eee', 'e10adc3949ba59abbe56e057f20f883e', NULL, '1', '0', 1, '2023-04-24 15:23:22', 1, '2024-09-23 15:19:19', NULL, NULL, NULL);
INSERT INTO `user_info` (`user_id`, `user_code`, `user_name`, `user_pwd`, `user_type`, `user_state`, `is_delete`, `create_by`, `create_time`, `update_by`, `update_time`, `mobile`, `email`, `avatar`) VALUES (33, 'fff', 'fff', 'e10adc3949ba59abbe56e057f20f883e', NULL, '0', '0', 1, '2023-04-24 15:23:48', 1, '2024-09-19 16:48:48', NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_message
-- ----------------------------
DROP TABLE IF EXISTS `user_message`;
CREATE TABLE `user_message` (
  `user_msg_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户站内信id',
  `msg_id` int(11) DEFAULT NULL COMMENT '站内信id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `state` char(1) DEFAULT '0' COMMENT '站内信状态：0 未读 1 已读',
  `from_user` int(11) DEFAULT NULL COMMENT '发信人id',
  `to_user` int(11) DEFAULT NULL COMMENT '收信人id',
  PRIMARY KEY (`user_msg_id`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COMMENT='用户站内信关系表';

-- ----------------------------
-- Records of user_message
-- ----------------------------
BEGIN;
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (26, 34, 3, '1', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (27, 35, 3, '0', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (28, 36, 3, '1', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (29, 37, 3, '0', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (30, 38, 3, '0', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (31, 39, 3, '0', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (32, 40, 3, '1', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (33, 41, 1, '1', 3, 1);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (34, 42, 1, '1', 3, 1);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (35, 43, 3, '1', 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (36, 44, 5, '0', 3, 5);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (37, 45, 5, '0', 3, 5);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (38, 46, 5, '0', 3, 5);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (39, 47, 5, '0', 1, 5);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (40, 48, 5, '0', 1, 5);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (41, 49, 3, '1', 5, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (42, 50, 3, NULL, 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (43, 51, 3, NULL, 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (44, 52, 3, NULL, 1, 3);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (45, 53, 1, '1', 3, 1);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (46, 53, 5, NULL, 3, 5);
INSERT INTO `user_message` (`user_msg_id`, `msg_id`, `user_id`, `state`, `from_user`, `to_user`) VALUES (47, 53, 6, NULL, 3, 6);
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `user_role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户角色对应id',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COMMENT='用户角色表';

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (11, 1, 7);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (12, 5, 7);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (13, 3, 6);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (14, 5, 6);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (15, 5, 9);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (20, 1, 1);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (23, 3, 5);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (25, 4, 5);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (26, 5, 5);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (27, 5, 19);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (28, 5, 20);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (49, 11, 28);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (51, 14, 30);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (52, 12, 29);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (53, 13, 31);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (54, 15, 32);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (55, 16, 33);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (57, 3, 35);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (58, 11, 3);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (59, 12, 3);
INSERT INTO `user_role` (`user_role_id`, `role_id`, `user_id`) VALUES (60, 3, 36);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
